Create Fundamental Staging table and popuated with data - Conitued 10


*Using SSIS Toolbox, the following components will be drag in the Control Flow Dashboard:

1.     Drag and drop the Excel Source – Double click and add the excel connection manager and select the sheet from the excel to load the data

2.     Drag and drop the derived column - use the Derived column Code - Add Column to pouplate the Filename and name the soruce file name.


3.      Drag and drop the Conditional Split - Double click and add condition to remove the Null values 

ISNULL(MSA) || ISNULL(YEAR) || ISNULL(STOCK) || ISNULL(COMPL) ||
ISNULL(ABSORP) || ISNULL([VAC %]) || ISNULL([OCC %]) || ISNULL(RENT) ||
ISNULL(RI) || ISNULL([OCC SF]) || ISNULL(Low) || ISNULL(Model) || ISNULL(High)



   4.      Drag and drop the Conditional Split - Double click and add condition to remove the Null values 


5.     Drag and drop the Data Conversion – and change the datatype 


6.       Drag and drop the Destination Source – Double click and add the OLE- DB connection manager and select the destination table




Repeat the Steps for all Fundamentals to load  the rest of 3 table.


Populate the Fundamental Tables with data after executing the package.



https://zappysys.com/blog/read-excel-file-ssis-load-sql-server/